{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["BinDist"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BinDist","index":0,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[18,1,18,2]]}
[]
[]
[]
[null,"No. of trials, N",20]
[null,"Null hypothesis H0 p",0.3]
[null,"Alternate hypothesis H1","prob ≠ p",null,"prob < p or prob > p"]
[null,"Significance level (%), s",5,null,"prob ≠ p"]
[]
[null,"expected value (N x p) is",{"$f":"n_trials*probH0","v":6}]
[null,"No. of tails is",{"$f":"IF(ISERR(FIND(\"≠\",alt_hyp)),1,2)","v":2}]
[]
[null,"Critical region criteron","strict",null,"as close as possible"]
[null,null,null,null,"strict"]
[]
[]
[]
[]
[]
[null,"Actual significance level",null,null,"r","nCr","pr","(1-p)n-r","P(X = r)","P(X ≤ r)","P(X ≥ r)"]
[null,"P(X ≤ 1 )",7.6372597741999971E-3,null,0,1,1,7.9792266297611894E-4,7.9792266297611894E-4,7.9792266297611894E-4,1]
[null,"P(X ≥ 11 )",1.7144816431259535E-2,null,1,20,0.3,1.139889518537313E-3,6.8393371112238782E-3,7.6372597741999971E-3,0.99920207733702393]
[null,null,{"$f":"TEXT((C20+C21)*100,\"0.00\")&\"%\"","v":"2.48%"},null,2,190,0.09,1.6284135979104471E-3,2.784587252426864E-2,3.5483132298468639E-2,0.99236274022579996]
[null,null,null,null,3,1140,2.6999999999999996E-2,2.3263051398720674E-3,7.1603672205262217E-2,0.10708680450373086,0.96451686770153133]
[null,null,null,null,4,4845,8.0999999999999996E-3,3.3232930569600965E-3,0.13042097437387049,0.23750777887760133,0.89291319549626913]
[null,null,null,null,5,15503.999999999998,2.4299999999999994E-3,4.7475615099429958E-3,0.17886305056987953,0.41637082944748083,0.76249222112239867]
[null,null,null,null,6,38760,7.2899999999999983E-4,6.7822307284899942E-3,0.19163898275344238,0.60800981220092321,0.58362917055251917]
[null,null,null,null,7,77520,2.1869999999999995E-4,9.6889010406999918E-3,0.16426198521723634,0.77227179741815954,0.39199018779907679]
[null,null,null,null,8,125970.00000000001,6.5609999999999977E-5,1.384128720099999E-2,0.11439673970486101,0.88666853712302052,0.22772820258184046]
[null,null,null,null,9,167960,1.9682999999999994E-5,1.9773267429999988E-2,6.5369565545634875E-2,0.95203810266865541,0.11333146287697948]
[null,null,null,null,10,184756,5.9048999999999975E-6,2.8247524899999984E-2,3.081708090008501E-2,0.98285518356874046,4.7961897331344594E-2]
[null,null,null,null,11,167960,1.7714699999999993E-6,4.0353606999999979E-2,1.2006654896137019E-2,0.99486183846487752,1.7144816431259535E-2]
[null,null,null,null,12,125970.00000000001,5.3144099999999976E-7,5.7648009999999972E-2,3.8592819309011843E-3,0.99872112039577876,5.1381615351224763E-3]
[null,null,null,null,13,77520,1.5943229999999992E-7,8.2354299999999964E-2,1.0178325971607518E-3,0.99973895299293947,1.2788796042212391E-3]
[null,null,null,null,14,38760,4.7829689999999973E-8,0.11764899999999996,2.181069851058754E-4,0.99995705997804529,2.6104700706053308E-4]
[null,null,null,null,15,15503.999999999998,1.4348906999999992E-8,0.16806999999999994,3.7389768875292926E-5,0.99999444974692053,4.2940021954707142E-5]
[null,null,null,null,16,4845,4.3046720999999976E-9,0.24009999999999995,5.0075583315124463E-6,0.99999945730525208,5.5502530794671046E-6]
[null,null,null,null,17,1140,1.2914016299999991E-9,0.34299999999999992,5.0496386536259949E-7,0.99999996226911747,5.4269474791812655E-7]
[null,null,null,null,18,190,3.8742048899999975E-10,0.48999999999999994,3.6068847525899971E-8,0.99999999833796505,3.7730882529452003E-8]
[null,null,null,null,19,20,1.1622614669999992E-10,0.7,1.6271660537999987E-9,0.99999999996513111,1.6620349541085488E-9]
[null,null,null,null,20,1,3.4867844009999975E-11,1,3.4867844009999975E-11,0.999999999999999,3.4868885556704754E-11]